TCustomDAConnection.ExecSQL Method

Executes a SQL statement with parameters.

Class

TCustomDAConnection

Syntax

function ExecSQL(const Text: string): variant; overload;function ExecSQL(const Text: string; const Params: array of variant): variant; overload; virtual;

Remarks

Use the ExecSQL method to execute any SQL statement outside the TCustomDADataSet or TCustomDASQL components. Supply the Params array with the values of parameters arranged in the same order as they appear in a SQL statement which itself is passed to the Text string parameter.

Note: If a query doesn't have parameters (Params.Count = 0), this query will be executed faster.

See Also

• ExecSQLEx
• ExecProc
• TCustomMyConnection.ExecSQL